<h2>Step 4 - Create Pending Jobs Table</h2>
<?php
$sql = "CREATE TABLE IF NOT EXISTS `pendingjobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `JobTitle` varchar(50) NOT NULL,
  `ContactNumber` varchar(15) NOT NULL,
  `ContactEmail` varchar(50) NOT NULL,
  `Wage` varchar(15) NOT NULL,
  `Hours` varchar(30) NOT NULL,
  `Description` longtext NOT NULL,
  `Employer` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";
$result = mysql_query($sql);
if (!$result) {
    die('Invalid query: ' . mysql_error());
}

echo "Step 4 Completed, Pending Jobs Table Created<br /><meta http-equiv='refresh' content='3;URL=index.php?step=done'><br />
<a href='index.php?step=done'>If you are not redirected in 3 seconds click here</a>";

?>
